package com.cmcc.groupcontacts.numbersearch.model;

import android.content.ContentValues;

import com.cmcc.groupcontacts.base.BaseModel;

public class NumberCategory extends BaseModel {

	/**
	 * 
	 */
	private static final long serialVersionUID = 7271261289695399943L;

	public String name;
	public int numberCount;
	
	public static class MetaData {
		public static final String id = "id";
		public static final String name = "name";
		public static final String numberCount = "number_count";
		public static final String[] ALL_COLS = { id, name, numberCount};
		public static String CREATE_DDL =
	            "CREATE TABLE numbercategory (" +
	                    "id INT PRIMARY KEY" +
	                    ", name VARCHAR" +
	                    ", number_count INT" +
	                    ")";
		public static String[] INSERT_DEFAULT = {
			"INSERT INTO numbercategory (id, name, number_count) VALUES (1,'报警应急',9);" ,
			"INSERT INTO numbercategory (id, name, number_count) VALUES (2,'生活常用',167);" ,
			"INSERT INTO numbercategory (id, name, number_count) VALUES (3,'政府电话',207);",
			"INSERT INTO numbercategory (id, name, number_count) VALUES (4,'通信服务',7);",
			"INSERT INTO numbercategory (id, name, number_count) VALUES (5,'银行热线',14);",
			"INSERT INTO numbercategory (id, name, number_count) VALUES (6,'保险公司',6);",
			"INSERT INTO numbercategory (id, name, number_count) VALUES (7,'物流快递',11);",
			"INSERT INTO numbercategory (id, name, number_count) VALUES (8,'订餐',10);",
			"INSERT INTO numbercategory (id, name, number_count) VALUES (9,'媒体',4);",
			"INSERT INTO numbercategory (id, name, number_count) VALUES (10,'知名企业',23);"};
	}

	@Override
	public ContentValues parse2ContentValues() {
		putValue(MetaData.name, name);
		putValue(MetaData.numberCount, numberCount);
		return contentValues;
	}

}
